UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't/QxWIRr4+jYYZDrzuHGaa7wXhlIZaUqYRMNq74v9cI='
WHERE
key_id = 'd3d29c20a9412b164f1caa420a8e5cc4502a1c44ae07f3d027664762a4cfe562'
AND (
token = 't/QxWIRr4+jYYZDrzuHGaa7wXhlIZaUqYRMNq74v9cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)