UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DxTLjzOfPnDkgv8KukYI/47aZNwOmWFchwV2+1xuujc='
WHERE
key_id = 'a18d53da4597fb358a1d6a66dac1586d842341773d6d6295b815d75edc8d518f'
AND (
token = 'DxTLjzOfPnDkgv8KukYI/47aZNwOmWFchwV2+1xuujc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)