UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VugpLgG7VCBxETQ6zJ9qFE//3Z7wxkbBV00LaBLEWKU='
WHERE
key_id = '5c45ad391d540d3b1864dd4564a1a5ff2fa0e96f01bae4bff2be946c6e88994a'
AND (
token = 'VugpLgG7VCBxETQ6zJ9qFE//3Z7wxkbBV00LaBLEWKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)