UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zhsdDM6+DvNgN/4+cNJQdZZ+rrwqkCZ+WRQzakKd9h4='
WHERE
key_id = 'd798b6d3f2df3c1cb7e4df20cf84b8c3fb7e099703b7f91f42d6ca7bc7537f50'
AND (
token = 'zhsdDM6+DvNgN/4+cNJQdZZ+rrwqkCZ+WRQzakKd9h4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)