UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4eFIOOwZZJC0SWaRD7kRkbbUF5YIeQMHyEWFeidQv4='
WHERE
key_id = 'b39e31f439b4737728aa5fee2983e847b4bed3bf08ef6dcf3219c5f9daecbbd1'
AND (
token = 'D4eFIOOwZZJC0SWaRD7kRkbbUF5YIeQMHyEWFeidQv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)