UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4aPgV5uHLZXshnHhk5F7GJXUuPgul0t5HO+lptj7eNg='
WHERE
key_id = '5980be10c9aa56e121087e630782702ca7256dfa54cd67e353119e72c99ca5fe'
AND (
token = '4aPgV5uHLZXshnHhk5F7GJXUuPgul0t5HO+lptj7eNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)