UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZLBxGpq5kocHO7zDz5tvKqvJRswJqYVolIrXAArfCs='
WHERE
key_id = '3ca9fe7b1189873b692ee46517f417420bc261798049efc322042d1a0e1a405b'
AND (
token = 'xZLBxGpq5kocHO7zDz5tvKqvJRswJqYVolIrXAArfCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)