UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDhd8ZemSx5Hn1YSXO3SScUWQuxPonhuWYjkPqLPb84='
WHERE
key_id = '4674bd2bf1cb8895de1fb78afd477537f2a5b666a513f12c6a6e6fcc0c871ea2'
AND (
token = 'zDhd8ZemSx5Hn1YSXO3SScUWQuxPonhuWYjkPqLPb84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)