UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vhsDcaqm+wGVO6AI+LtPFEPS0I3IOKpeJ+jPFtc9Uk='
WHERE
key_id = 'b4178c8ec460f491f8264c9f3239e879019acb769f93b68d35cb431596585187'
AND (
token = '6vhsDcaqm+wGVO6AI+LtPFEPS0I3IOKpeJ+jPFtc9Uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)