UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZEa1+gmafiA2DZlht4KNRuEErRyTww0sK1vTQjVTvg='
WHERE
key_id = '02c4ae7e9e9c71dd1c81a15065d7b0773817cd20b99e34af66b8b20810f663f3'
AND (
token = 'LZEa1+gmafiA2DZlht4KNRuEErRyTww0sK1vTQjVTvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)