UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Haz4im6wCswbwSEYSMlCLCDYiqwwtcQOKOW8neHAoA='
WHERE
key_id = 'cb3a3a9c5eed0b2e86944a2bab973e3c6c18994a999766185b1483fe1afd70bf'
AND (
token = '3Haz4im6wCswbwSEYSMlCLCDYiqwwtcQOKOW8neHAoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)