UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpR5HEBJPJVIosa6r4KBPIBtfL/cBwcJws93I3JM0tA='
WHERE
key_id = '7be1e7fbbd707870d1c47cdefb4c1b2f4030e585cf9b5c1f42b2777b6e639d90'
AND (
token = 'BpR5HEBJPJVIosa6r4KBPIBtfL/cBwcJws93I3JM0tA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)