UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sIHVYDOVjlzuexg2VXvtv56qqKI7mLsfWyym7j4inm8='
WHERE
key_id = 'fa0283019273d21c5e3cc915b8f9cc8ca750fe5de572a9a3ae9b9577baa20dbf'
AND (
token = 'sIHVYDOVjlzuexg2VXvtv56qqKI7mLsfWyym7j4inm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)