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