UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'giSeO6JhYp3d+4PfmCdaKr+cpNbJ3rgH2naWtpggtX0='
WHERE
key_id = '8f1fb1e648334bdefc0ecdf00d3344df72473d46f134a7c0fe7f2ed5590e6db9'
AND (
token = 'giSeO6JhYp3d+4PfmCdaKr+cpNbJ3rgH2naWtpggtX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)