UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7k7ymkKsA8uD6fjU3trj7gAkOLeZ7h+zmYrvJmyXF8='
WHERE
key_id = 'ba40302d68212d19a3505337577be5f3ad01ffd77b0600e63d2e64e4da8e9df0'
AND (
token = 'q7k7ymkKsA8uD6fjU3trj7gAkOLeZ7h+zmYrvJmyXF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)