UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DU/3VqnlZY33bb7M3IDJbKhUhoMfC/i29YS8QSs11Jk='
WHERE
key_id = 'a4616b028891c8331f1952777001c52b7bd4507e7ead6702e3feb8a6f3a7221d'
AND (
token = 'DU/3VqnlZY33bb7M3IDJbKhUhoMfC/i29YS8QSs11Jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)