UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7Gi6IUzsRLfwXO9FZQ0SUM23TDqw1F+UpSMg9624j4='
WHERE
key_id = 'bcf8d04749579b4ad586f7fa647d2d0e9ce85cb48dac45263eabdacbbcd7a40d'
AND (
token = 'd7Gi6IUzsRLfwXO9FZQ0SUM23TDqw1F+UpSMg9624j4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)