UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eet7yyXTIsiUTTiU/N1/uHMXdSmHpmBvGYcjtIr9YOI='
WHERE
key_id = 'f68d27a3dccec51ce9f2f943728421eb0f9746602f7917a9592a045117d6300a'
AND (
token = 'eet7yyXTIsiUTTiU/N1/uHMXdSmHpmBvGYcjtIr9YOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)