UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/TsVhsZg53Jg4grkcHdVuSq69iMBb24LHJn8t72iCe8='
WHERE
key_id = 'c1fd6ab11e8a6ac10fdd591146a47c752f79926e1faa5a7a741a041dd45c0d79'
AND (
token = '/TsVhsZg53Jg4grkcHdVuSq69iMBb24LHJn8t72iCe8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)