UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UNBwYf6uqfq1mlaftlFqcj2M/pAllS0bg0oqhP3YAes='
WHERE
key_id = 'f7e6d3b1c7b5e15e7a74741791c489dabb55d3f8b7dc820bdbb3c97ce6885704'
AND (
token = 'UNBwYf6uqfq1mlaftlFqcj2M/pAllS0bg0oqhP3YAes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)