UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HjjcrKq62Cyv6QfoDzo33OSZm5486KuOFE5HwzmkkaU='
WHERE
key_id = '815115c6cd600e66395b148ba7f121d68d5bf43d6b3609306e1d5cf2a5810c9c'
AND (
token = 'HjjcrKq62Cyv6QfoDzo33OSZm5486KuOFE5HwzmkkaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)