UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zlmRcix5rrJMOvn0rAmjb1PVcN50uHnVpIx6XIPIAY='
WHERE
key_id = '93b05a7b411a6ae3a5c6253bb58136ba7efe992e9b1bd9740b4ecb15657603ad'
AND (
token = '0zlmRcix5rrJMOvn0rAmjb1PVcN50uHnVpIx6XIPIAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)