UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDieGZcV9OmTSKBSV251kCJK61Lx4CvbokAKYXsajyI='
WHERE
key_id = '0394c6d3ba7a22a7bdf9b1f834db37023ac8560efbb60ee8878d1710e6b4fe5e'
AND (
token = 'zDieGZcV9OmTSKBSV251kCJK61Lx4CvbokAKYXsajyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)