UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RoeRKb9qTSQaoX+V6bYU2a5Wb57LUv3CnKdE0VlUV7M='
WHERE
key_id = 'd677839190e29e4f9a8c32e31e728c6e4cb6271f02da78c4c92107e7d3808afb'
AND (
token = 'RoeRKb9qTSQaoX+V6bYU2a5Wb57LUv3CnKdE0VlUV7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)