UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0i1Y1ZP9awVUECXRTJqyvdBsca+6js+nEEpb4HaunPA='
WHERE
key_id = '30f74c2f360423fcdd10e37c701cf8aa3ef039972644e24f4422ee51e3c0304e'
AND (
token = '0i1Y1ZP9awVUECXRTJqyvdBsca+6js+nEEpb4HaunPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)