UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+J+11ZKJ+q3CudnBy5qP7PkLXzzPcpw7jJ4qWyBiqI='
WHERE
key_id = '794408b8004e50b0cb1bf563b2141a24ddaf33021bfee2d3b57f62ec1d703bd2'
AND (
token = 'Z+J+11ZKJ+q3CudnBy5qP7PkLXzzPcpw7jJ4qWyBiqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)