UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4Bf9LFYV51ZYCuwHDZBRM6+4Qtz4V25Rz6yFRgfTig='
WHERE
key_id = '1c5de19509212c85b2ec5e5af2763bfc398cbe43a08901639013df6bec3b1648'
AND (
token = 'a4Bf9LFYV51ZYCuwHDZBRM6+4Qtz4V25Rz6yFRgfTig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)