UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfUMgilcRI/jDI9fBfZTAxXi0VBSF3kY2PQYk5urhIU='
WHERE
key_id = 'be496ca98f47b0433ccd1109ad73c858468021f20d7b61290a3968e0ed461901'
AND (
token = 'pfUMgilcRI/jDI9fBfZTAxXi0VBSF3kY2PQYk5urhIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)