UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lxJ23jjmj2EhKqHAKgmCFFc1Hy71h5XemwHiHQCrS/U='
WHERE
key_id = 'dad7133f2184ca9e7c64cc40338274eedbaf36b329f0e6e62be19f5e2950ac12'
AND (
token = 'lxJ23jjmj2EhKqHAKgmCFFc1Hy71h5XemwHiHQCrS/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)