UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LJD7ow0M7/TE/f7lZzpG94lv7OnVeDHMASUAkQr8NNo='
WHERE
key_id = '5e05a7020a51f95c337698e96499356a2b487554c627be0164978872b810eb3a'
AND (
token = 'LJD7ow0M7/TE/f7lZzpG94lv7OnVeDHMASUAkQr8NNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)